package cn.com.xy.sms.sdk.db.entity;


/**
 * 短信中心归属地
 * @author Administrator
 *
 */
public class CenterNumLocationInfo {

	public int id;  //标识
	public String cNum;//短信中心号码(前7位)去掉+86,86,+后的
	public String areaCode;//省份编码
	public String province;//省份
	public String city;//城市
	public String operator;//运营商
	public long checkTime;//检测时间
/*	@Override
	public String toString() {
		return "CenterNumLocationInfo [id=" + id + ", cNum=" + cNum
				+ ", areaCode=" + areaCode + ", province=" + province
				+ ", city=" + city + ", operator=" + operator + "]";
	}*/
	
	public static final String TABLE_NAME="tb_centernum_location_info";
	public static final String DROP_TABLE = " DROP TABLE IF EXISTS " + TABLE_NAME;
	public static final String CREATE_TABLE = " create table  if not exists "  + TABLE_NAME + " ("+
											" id INTEGER PRIMARY KEY,"+
											" cnum TEXT not null unique," +
											" areaCode TEXT,"+
											" city TEXT,"+
											" checkTime long,"+
											" operator TEXT )";
	
}
